{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":110,"n_cols":10,"rows_kept":110,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,"Quadro do Projecto Hotel"]
[null,"Ex. 5.10 - Sim. Projecto Hotel ",null,null,null,null,null,"(100 Runs)"]
[]
[null,null,"Tx Actualização",null,{"$f":"0.1","v":0.1}]
[null,null,"NPV(0,1) - Mil €",null,{"$f":"NPV(E5,F13:F20)","v":-365.63132279664654},null,null,"Run","NPV - Mil €","TIR - %"]
[null,null,"IRR (%)",null,{"$f":"IRR(F13:F20)*100","v":6.0266244980870853},null,null,"Média",{"$f":"AVERAGE(I10:I110)","v":541.70251262658905},{"$f":"AVERAGE(J10:J110)","v":13.281080820142606}]
[null,null,null,null,null,null,null,"D. Padrão (*)",{"$f":"STDEV(I10:I110)","v":897.60982067360862},{"$f":"STDEV(J10:J110)","v":6.7049198120038076}]
[]
[null,null,null,null,null,null,null,null,{"$f":"+E6","v":-365.63132279664654},{"$f":"+E7","v":6.0266244980870853}]
[null,null,null,null,null,null,null,1,1449.8565743564077,19.81425980165017]
[null,"Ano",null,"Cash - Flow (Mil €)",null,"Gerado",null,{"$f":"+H11+1","v":2},-204.79614060190607,8.0746308907595719]
[null,0,"Normal(μ;σ)",-800,null,{"$f":"+D13","v":-800},null,{"$f":"+H12+1","v":3},1614.8922085910299,20.853905077180368]
[null,1,"Normal(μ;σ)",-800,50,{"$f":"NORMINV(RAND(),D14,E14)","v":-729.29211042568113},null,4,605.36766108824054,14.464851633767895]
[null,2,"Normal(μ;σ)",-800,100,-778.39412878913402,null,5,-202.58291308636629,7.8867949466465692]
[null,3,"Normal(μ;σ)",-700,150,-251.28428813755329,null,6,-782.47351802988032,2.0061389724732148]
[null,4,"Normal(μ;σ)",300,200,243.49061602111593,null,7,-644.50530774644631,3.1315098536741193]
[null,5,"Normal(μ;σ)",400,200,415.97231247911196,null,8,1496.0242354864636,20.09302462758842]
[null,6,"Normal(μ;σ)",500,200,440.69593489045769,null,9,-473.73508367454627,5.7121211149454787]
[null,7,"Uniforme(a;b",2000,8440,{"$f":"+D20+RAND()*(E20-D20)","v":2376.5347465204882},null,10,473.80090050228233,13.565548985251642]
[null,null,null,null,null,null,null,11,-431.21985463564977,6.2348065626542493]
[null,null,null,null,null,null,null,12,-530.69973583585841,4.4800254266768924]
[null,null,null,null,null,null,null,13,-570.66733591872389,4.4030054437849131]
[null,"Intervalo de Confiança a ",null,0.95,null,null,null,14,1564.5579952202449,20.659077558846906]
[null,null,null,null,null,null,null,15,-51.910670533945691,9.5775895679425247]
[null,"NPV",null,null,"IRR",null,null,16,419.58733941324181,13.619019173165015]
[null,"L. Inferior","L. Superior",null,"L. Inferior","L. Superior",null,17,1828.2418872674421,22.21123609480664]
[null,null,null,null,null,null,null,18,1667.9814365044272,20.502518997288099]
[null,{"$f":"+$I$7-$I$8/SQRT($H$110)*TINV(1-$D$24,$H$110-1)","v":363.59725041748732},{"$f":"+$I$7+$I$8/SQRT($H$110)*TINV(1-$D$24,$H$110-1)","v":719.80777483569079},null,{"$f":"+$J$7-$J$8/SQRT($H$110)*TINV(1-$D$24,$H$110-1)","v":11.95067926514205},{"$f":"+$J$7+$J$8/SQRT($H$110)*TINV(1-$D$24,$H$110-1)","v":14.611482375143162},null,19,-434.95388977838746,5.6089057155471966]
[null,null,null,null,null,null,null,20,370.08229443775855,13.34135880891667]
[null,null,null,null,null,null,null,21,2512.2435015040437,25.743931028182732]
[null,"(*) O Excel já dá o Desvio Padrão Corrigido.",null,null,null,null,null,22,-39.94297933807853,9.6476492712660686]
[null,null,null,null,null,null,null,23,680.93134464908985,15.383009429394946]
[null,null,null,null,null,null,null,24,1543.542723893029,21.004612703019674]
[null,null,null,null,null,null,null,25,233.33242217757822,11.874521026686535]
[null,null,null,null,null,null,null,26,-342.61766946415304,6.6500232658070368]
[null,null,null,null,null,null,null,27,-14.852117073482159,9.8796693807727376]
[null,null,null,null,null,null,null,28,-160.33877545166143,8.6741645216374508]
[null,null,null,null,null,null,null,29,1639.737681079446,21.381322998374962]
[null,null,null,null,null,null,null,30,-927.93603124163997,0.91391015080208859]
[null,null,null,null,null,null,null,31,2212.2113975347097,23.602097356215435]
[null,null,null,null,null,null,null,32,856.18871078367079,16.429403072753203]
[null,null,null,null,null,null,null,33,1195.7676109930997,18.6744587603912]
[null,null,null,null,null,null,null,34,-12.513320500864788,9.8931972999595885]
[null,null,null,null,null,null,null,35,1434.4252605646568,19.804049669729594]
[null,null,null,null,null,null,null,36,1643.7681504183977,20.630037894612975]
[null,null,null,null,null,null,null,37,713.84883695937037,15.593377786189166]
[null,null,null,null,null,null,null,38,665.52167759780014,15.342684901641611]
[null,null,null,null,null,null,null,39,-419.95329581497424,6.1264837053545129]
[null,null,null,null,null,null,null,40,1655.8749340885445,21.132756902153972]
[null,null,null,null,null,null,null,41,-166.6880485190801,8.5800822546175937]
[null,null,null,null,null,null,null,42,-596.43071407228854,3.6977639364489612]
[null,null,null,null,null,null,null,43,-577.4609659007416,4.6034795630168768]
[null,null,null,null,null,null,null,44,810.39512542776652,16.399154240583137]
[null,null,null,null,null,null,null,45,-65.120588607103187,9.4172168905635409]
[null,null,null,null,null,null,null,46,1437.8360156410049,19.710388574803872]
[null,null,null,null,null,null,null,47,-59.480299662632405,9.4153548170547552]
[null,null,null,null,null,null,null,48,-175.23437504222389,8.3662175583643528]
[null,null,null,null,null,null,null,49,-666.47569889541478,3.1910837872348941]
[null,null,null,null,null,null,null,50,1863.143235502293,21.619271636127891]
[null,null,null,null,null,null,null,51,1206.7263342595252,18.034811515522307]
[null,null,null,null,null,null,null,52,950.6786972357196,16.878808264581725]
[null,null,null,null,null,null,null,53,1393.7225295870439,19.482220838476707]
[null,null,null,null,null,null,null,54,1381.1619069971493,18.805411503725612]
[null,null,null,null,null,null,null,55,1924.7595748887586,22.226494731937429]
[null,null,null,null,null,null,null,56,298.23055050246899,12.23025830259914]
[null,null,null,null,null,null,null,57,-52.710462980337724,9.5705221350519398]
[null,null,null,null,null,null,null,58,1141.4335131682781,17.689618471470681]
[null,null,null,null,null,null,null,59,2050.7841265642282,23.414969198594559]
[null,null,null,null,null,null,null,60,601.81725558233779,14.706586209601458]
[null,null,null,null,null,null,null,61,-109.49850468520479,8.9291513367009792]
[null,null,null,null,null,null,null,62,520.18368777788749,14.089959274723384]
[null,null,null,null,null,null,null,63,80.747621220680642,10.674089069494519]
[null,null,null,null,null,null,null,64,-477.25573518774246,5.3314949152677871]
[null,null,null,null,null,null,null,65,1275.157695261677,19.398214420694117]
[null,null,null,null,null,null,null,66,546.2316208843007,14.082397531749979]
[null,null,null,null,null,null,null,{"$f":"+H76+1","v":67},942.76437287248029,17.188392344970804]
[null,null,null,null,null,null,null,68,333.78127617412866,12.4969284600704]
[null,null,null,null,null,null,null,69,498.12213708092708,13.831639596282175]
[null,null,null,null,null,null,null,70,1264.6789208877728,19.14106319562223]
[null,null,null,null,null,null,null,71,-1303.7353818931722,-4.0812995987949634]
[null,null,null,null,null,null,null,72,1705.9486564295305,21.544843855907246]
[null,null,null,null,null,null,null,73,-764.66595407978105,1.7271722213001661]
[null,null,null,null,null,null,null,74,1141.8583083712672,18.449517943307427]
[null,null,null,null,null,null,null,75,1925.4076050531569,22.417320552622442]
[null,null,null,null,null,null,null,76,595.26930119381916,14.694471828135836]
[null,null,null,null,null,null,null,77,1311.264924191953,19.16522435722905]
[null,null,null,null,null,null,null,78,-785.42969423865452,3.1627668772244988]
[null,null,null,null,null,null,null,79,-530.55871360792992,5.1896431024863077]
[null,null,null,null,null,null,null,80,1578.6364598340415,19.548254539194222]
[null,null,null,null,null,null,null,81,-480.21911180936718,5.2403424209571448]
[null,null,null,null,null,null,null,82,170.60211622208456,11.403648508946528]
[null,null,null,null,null,null,null,83,19.328521555311948,10.167609879011064]
[null,null,null,null,null,null,null,84,-430.05957370334062,5.597335179991858]
[null,null,null,null,null,null,null,85,-568.59147627708842,4.243646369866072]
[null,null,null,null,null,null,null,86,-201.44208351916981,8.2924684209539024]
[null,null,null,null,null,null,null,87,790.04987283852984,15.965260208515787]
[null,null,null,null,null,null,null,88,1558.5573768304414,21.177241331714281]
[null,null,null,null,null,null,null,89,1634.7958917034052,21.22616561208417]
[null,null,null,null,null,null,null,90,589.37016510631145,14.144879872498283]
[null,null,null,null,null,null,null,91,-817.6603682883075,1.6009115135246832]
[null,null,null,null,null,null,null,92,1739.2909904167848,21.299764613335135]
[null,null,null,null,null,null,null,93,152.36287655931267,11.233874678012468]
[null,null,null,null,null,null,null,94,380.19301852287794,13.091386099641266]
[null,null,null,null,null,null,null,95,-115.78362695645161,8.9933625825218577]
[null,null,null,null,null,null,null,96,1641.9956409749745,21.233117811938861]
[null,null,null,null,null,null,null,97,744.29110635883501,15.34785480378571]
[null,null,null,null,null,null,null,98,1523.7894907712482,20.551242463499374]
[null,null,null,null,null,null,null,99,1180.4255912066012,17.985706698823623]
[null,null,null,null,null,null,null,100,884.2042179668673,16.92406863361564]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}